package com.itheima.health.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.itheima.health.pojo.Member;
import org.apache.ibatis.annotations.Select;

import java.util.List;
import java.util.Map;

@SuppressWarnings("ALL")
/**
 * @Description :
 * @author     :LD
 */
public interface MemberMapper extends BaseMapper<Member> {
    @Select("SELECT  count(tm.ID) as memberCounts, concat(year(rp.fdate),'-',rp.fmonth) as yearAndMonth from rpt_date  rp  ,t_member  tm where rp.fdate = tm.REGTIME and rp.fyear = year(now())-1 group by rp.fmonth")
    List<Map> getMemberCount();
}
